Feb 2026 sample data — Cancelled Report vs Failed Delivery Report | Verified 2026-05-10
Cancelled report
Failed delivery report
Pre-ship cancellations — no stock or financial impact
Filter 1 — no resi
Buyer cancelled, unpaid, system timeout
1,253 orders
--
Not present
Post-ship, buyer-initiated cancellation (not a delivery failure)
Filter 2 — has resi, buyer cancelled
"Berubah pikiran", "Change address"
2 orders
--
Not present
Delivery failures — Batal orders (69 orders appear in both reports)
Filter 3 — "Paket hilang di perjalanan"
Compensation auto-credited to seller
2 orders
↔
3A — Batal + Paket Hilang/Rusak
Package lost/damaged during return
3 orders
Filter 4 — "Pengiriman gagal"
Catch-all: can't distinguish returned vs lost from this report alone
67 orders
↔
4A — Batal + Selesai Dikirim ke Penjual
Package returned to seller
66 orders
Filter 3 + Filter 4
=
69 orders
=
3A + 4A
Post-receipt returns — Selesai orders (exclusive to Failed Delivery)
Not present
←
3B — Selesai + Paket Hilang/Rusak
Buyer returned, package lost in return transit
3 orders
Not present
←
4B — Selesai + Selesai Dikirim ke Penjual
Buyer returned, package back at seller
6 orders
Ops KPI only — not a delivery failure
Separate — "Penjual gagal mengirimkan tepat waktu"
Late shipment, has resi but no ship date
2 orders
--
Not present
Verified rules
Rule 1 — Selesai exclusion
If Status Pesanan = Selesai in the Failed Delivery Report, the order will NOT appear in the Cancelled Report. These are post-receipt customer returns (3B, 4B). Total: 9 orders.
Rule 2 — Batal equivalence
"Paket hilang" + "Pengiriman gagal" orders in Cancelled Report = all Batal orders in Failed Delivery Report. Exact match: 69 = 69, same order set.
Implication
The Failed Delivery Report is the primary working source — it has the 3A/4A split that the Cancelled Report can't provide, plus the 3B/4B Selesai returns that are exclusive to it.